/*
Building a Clean and Loyal State: The Strategic Dilemma of an Anti-corruption Campaign Under One-Party Rule
Authors: Tianyang Xi, Yang Yao and Qian Zhang
Date: Oct, 30, 2023
Stata Version 14.0
Operating System: Micrsoft Windows 10
*/

clear
set more off
capture log close

*-------------------------------Table A1------------------------------------*
*Part 1 : individual-level variables
use "investigation_2013_2021.dta" ,clear
drop if lm==. |ability==. | connectionc_yes==. | college_yes==. | mini_nat==. | gender==. 
sum lm ability connectionc_yes connectionc college_yes mini_nat gender xs_2014 xs_2015 xs_2016 xs_2017 xs_2018 xs_2019 xs_2020 xs_2021

*Part 2 : City-year-level variables
use "promotion.dta", clear
drop if promotion==. |ability==. | connectionc_yes==. | college==. | mini_nat==. | gender==. | age==. 
sum promotion ability connectionc_yes college mini_nat gender age
